Login     Sign up
SQL query error!
Craig Hopson (@craighopson)
Join date: Mar 24th 2011
Community posts: 26
View Profile
Send Message

SQL query error!
Error infomation:[SQL]
SELECT u.* FROM jcow_friends as f1 inner join jcow_friends as f2 on f1.fid = f2.fid left join jcow_accounts as u on f1.fid=u.id where f1.uid=7 and f2.uid= ORDER BY f1.created DESC LIMIT 30

[Error]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY f1.created DESC LIMIT 30' at line 1

158 months ago
Jcow Master (@falcone)
Join date: Sep 2nd 2010
Community posts: 917
View Profile
Send Message

i guess this is the mutual friends code in u.module.php, function show_sidebar

[code]
if ( ($client['id']) && ($client['id'] != ($owner['id']) )) {

///// mutual friends code

}
[/code]

158 months ago
Craig Hopson (@craighopson)
Join date: Mar 24th 2011
Community posts: 26
View Profile
Send Message

ok what should i do delete it?? i dont use mutual friend

158 months ago
Jcow Master (@falcone)
Join date: Sep 2nd 2010
Community posts: 917
View Profile
Send Message

you can delete the code or put the if statement around the code

158 months ago
Craig Hopson (@craighopson)
Join date: Mar 24th 2011
Community posts: 26
View Profile
Send Message

Thanks buddie

158 months ago